package com.runfast.waimai.dao.model;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class WaiMaiRunfastAgentbusinessExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public WaiMaiRunfastAgentbusinessExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andAreasIsNull() {
            addCriterion("areas is null");
            return (Criteria) this;
        }

        public Criteria andAreasIsNotNull() {
            addCriterion("areas is not null");
            return (Criteria) this;
        }

        public Criteria andAreasEqualTo(String value) {
            addCriterion("areas =", value, "areas");
            return (Criteria) this;
        }

        public Criteria andAreasNotEqualTo(String value) {
            addCriterion("areas <>", value, "areas");
            return (Criteria) this;
        }

        public Criteria andAreasGreaterThan(String value) {
            addCriterion("areas >", value, "areas");
            return (Criteria) this;
        }

        public Criteria andAreasGreaterThanOrEqualTo(String value) {
            addCriterion("areas >=", value, "areas");
            return (Criteria) this;
        }

        public Criteria andAreasLessThan(String value) {
            addCriterion("areas <", value, "areas");
            return (Criteria) this;
        }

        public Criteria andAreasLessThanOrEqualTo(String value) {
            addCriterion("areas <=", value, "areas");
            return (Criteria) this;
        }

        public Criteria andAreasLike(String value) {
            addCriterion("areas like", value, "areas");
            return (Criteria) this;
        }

        public Criteria andAreasNotLike(String value) {
            addCriterion("areas not like", value, "areas");
            return (Criteria) this;
        }

        public Criteria andAreasIn(List<String> values) {
            addCriterion("areas in", values, "areas");
            return (Criteria) this;
        }

        public Criteria andAreasNotIn(List<String> values) {
            addCriterion("areas not in", values, "areas");
            return (Criteria) this;
        }

        public Criteria andAreasBetween(String value1, String value2) {
            addCriterion("areas between", value1, value2, "areas");
            return (Criteria) this;
        }

        public Criteria andAreasNotBetween(String value1, String value2) {
            addCriterion("areas not between", value1, value2, "areas");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNull() {
            addCriterion("createTime is null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNotNull() {
            addCriterion("createTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeEqualTo(Date value) {
            addCriterion("createTime =", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotEqualTo(Date value) {
            addCriterion("createTime <>", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThan(Date value) {
            addCriterion("createTime >", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("createTime >=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThan(Date value) {
            addCriterion("createTime <", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThanOrEqualTo(Date value) {
            addCriterion("createTime <=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIn(List<Date> values) {
            addCriterion("createTime in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotIn(List<Date> values) {
            addCriterion("createTime not in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeBetween(Date value1, Date value2) {
            addCriterion("createTime between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotBetween(Date value1, Date value2) {
            addCriterion("createTime not between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andMobileIsNull() {
            addCriterion("mobile is null");
            return (Criteria) this;
        }

        public Criteria andMobileIsNotNull() {
            addCriterion("mobile is not null");
            return (Criteria) this;
        }

        public Criteria andMobileEqualTo(String value) {
            addCriterion("mobile =", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotEqualTo(String value) {
            addCriterion("mobile <>", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileGreaterThan(String value) {
            addCriterion("mobile >", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileGreaterThanOrEqualTo(String value) {
            addCriterion("mobile >=", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLessThan(String value) {
            addCriterion("mobile <", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLessThanOrEqualTo(String value) {
            addCriterion("mobile <=", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLike(String value) {
            addCriterion("mobile like", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotLike(String value) {
            addCriterion("mobile not like", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileIn(List<String> values) {
            addCriterion("mobile in", values, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotIn(List<String> values) {
            addCriterion("mobile not in", values, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileBetween(String value1, String value2) {
            addCriterion("mobile between", value1, value2, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotBetween(String value1, String value2) {
            addCriterion("mobile not between", value1, value2, "mobile");
            return (Criteria) this;
        }

        public Criteria andNameIsNull() {
            addCriterion("name is null");
            return (Criteria) this;
        }

        public Criteria andNameIsNotNull() {
            addCriterion("name is not null");
            return (Criteria) this;
        }

        public Criteria andNameEqualTo(String value) {
            addCriterion("name =", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotEqualTo(String value) {
            addCriterion("name <>", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThan(String value) {
            addCriterion("name >", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualTo(String value) {
            addCriterion("name >=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThan(String value) {
            addCriterion("name <", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualTo(String value) {
            addCriterion("name <=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLike(String value) {
            addCriterion("name like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotLike(String value) {
            addCriterion("name not like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameIn(List<String> values) {
            addCriterion("name in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotIn(List<String> values) {
            addCriterion("name not in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameBetween(String value1, String value2) {
            addCriterion("name between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotBetween(String value1, String value2) {
            addCriterion("name not between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andAgentidIsNull() {
            addCriterion("agentId is null");
            return (Criteria) this;
        }

        public Criteria andAgentidIsNotNull() {
            addCriterion("agentId is not null");
            return (Criteria) this;
        }

        public Criteria andAgentidEqualTo(Integer value) {
            addCriterion("agentId =", value, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidNotEqualTo(Integer value) {
            addCriterion("agentId <>", value, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidGreaterThan(Integer value) {
            addCriterion("agentId >", value, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidGreaterThanOrEqualTo(Integer value) {
            addCriterion("agentId >=", value, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidLessThan(Integer value) {
            addCriterion("agentId <", value, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidLessThanOrEqualTo(Integer value) {
            addCriterion("agentId <=", value, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidIn(List<Integer> values) {
            addCriterion("agentId in", values, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidNotIn(List<Integer> values) {
            addCriterion("agentId not in", values, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidBetween(Integer value1, Integer value2) {
            addCriterion("agentId between", value1, value2, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidNotBetween(Integer value1, Integer value2) {
            addCriterion("agentId not between", value1, value2, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentnameIsNull() {
            addCriterion("agentName is null");
            return (Criteria) this;
        }

        public Criteria andAgentnameIsNotNull() {
            addCriterion("agentName is not null");
            return (Criteria) this;
        }

        public Criteria andAgentnameEqualTo(String value) {
            addCriterion("agentName =", value, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameNotEqualTo(String value) {
            addCriterion("agentName <>", value, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameGreaterThan(String value) {
            addCriterion("agentName >", value, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameGreaterThanOrEqualTo(String value) {
            addCriterion("agentName >=", value, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameLessThan(String value) {
            addCriterion("agentName <", value, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameLessThanOrEqualTo(String value) {
            addCriterion("agentName <=", value, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameLike(String value) {
            addCriterion("agentName like", value, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameNotLike(String value) {
            addCriterion("agentName not like", value, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameIn(List<String> values) {
            addCriterion("agentName in", values, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameNotIn(List<String> values) {
            addCriterion("agentName not in", values, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameBetween(String value1, String value2) {
            addCriterion("agentName between", value1, value2, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameNotBetween(String value1, String value2) {
            addCriterion("agentName not between", value1, value2, "agentname");
            return (Criteria) this;
        }

        public Criteria andCityidIsNull() {
            addCriterion("cityId is null");
            return (Criteria) this;
        }

        public Criteria andCityidIsNotNull() {
            addCriterion("cityId is not null");
            return (Criteria) this;
        }

        public Criteria andCityidEqualTo(String value) {
            addCriterion("cityId =", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidNotEqualTo(String value) {
            addCriterion("cityId <>", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidGreaterThan(String value) {
            addCriterion("cityId >", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidGreaterThanOrEqualTo(String value) {
            addCriterion("cityId >=", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidLessThan(String value) {
            addCriterion("cityId <", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidLessThanOrEqualTo(String value) {
            addCriterion("cityId <=", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidLike(String value) {
            addCriterion("cityId like", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidNotLike(String value) {
            addCriterion("cityId not like", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidIn(List<String> values) {
            addCriterion("cityId in", values, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidNotIn(List<String> values) {
            addCriterion("cityId not in", values, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidBetween(String value1, String value2) {
            addCriterion("cityId between", value1, value2, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidNotBetween(String value1, String value2) {
            addCriterion("cityId not between", value1, value2, "cityid");
            return (Criteria) this;
        }

        public Criteria andCitynameIsNull() {
            addCriterion("cityName is null");
            return (Criteria) this;
        }

        public Criteria andCitynameIsNotNull() {
            addCriterion("cityName is not null");
            return (Criteria) this;
        }

        public Criteria andCitynameEqualTo(String value) {
            addCriterion("cityName =", value, "cityname");
            return (Criteria) this;
        }

        public Criteria andCitynameNotEqualTo(String value) {
            addCriterion("cityName <>", value, "cityname");
            return (Criteria) this;
        }

        public Criteria andCitynameGreaterThan(String value) {
            addCriterion("cityName >", value, "cityname");
            return (Criteria) this;
        }

        public Criteria andCitynameGreaterThanOrEqualTo(String value) {
            addCriterion("cityName >=", value, "cityname");
            return (Criteria) this;
        }

        public Criteria andCitynameLessThan(String value) {
            addCriterion("cityName <", value, "cityname");
            return (Criteria) this;
        }

        public Criteria andCitynameLessThanOrEqualTo(String value) {
            addCriterion("cityName <=", value, "cityname");
            return (Criteria) this;
        }

        public Criteria andCitynameLike(String value) {
            addCriterion("cityName like", value, "cityname");
            return (Criteria) this;
        }

        public Criteria andCitynameNotLike(String value) {
            addCriterion("cityName not like", value, "cityname");
            return (Criteria) this;
        }

        public Criteria andCitynameIn(List<String> values) {
            addCriterion("cityName in", values, "cityname");
            return (Criteria) this;
        }

        public Criteria andCitynameNotIn(List<String> values) {
            addCriterion("cityName not in", values, "cityname");
            return (Criteria) this;
        }

        public Criteria andCitynameBetween(String value1, String value2) {
            addCriterion("cityName between", value1, value2, "cityname");
            return (Criteria) this;
        }

        public Criteria andCitynameNotBetween(String value1, String value2) {
            addCriterion("cityName not between", value1, value2, "cityname");
            return (Criteria) this;
        }

        public Criteria andCountyidIsNull() {
            addCriterion("countyId is null");
            return (Criteria) this;
        }

        public Criteria andCountyidIsNotNull() {
            addCriterion("countyId is not null");
            return (Criteria) this;
        }

        public Criteria andCountyidEqualTo(String value) {
            addCriterion("countyId =", value, "countyid");
            return (Criteria) this;
        }

        public Criteria andCountyidNotEqualTo(String value) {
            addCriterion("countyId <>", value, "countyid");
            return (Criteria) this;
        }

        public Criteria andCountyidGreaterThan(String value) {
            addCriterion("countyId >", value, "countyid");
            return (Criteria) this;
        }

        public Criteria andCountyidGreaterThanOrEqualTo(String value) {
            addCriterion("countyId >=", value, "countyid");
            return (Criteria) this;
        }

        public Criteria andCountyidLessThan(String value) {
            addCriterion("countyId <", value, "countyid");
            return (Criteria) this;
        }

        public Criteria andCountyidLessThanOrEqualTo(String value) {
            addCriterion("countyId <=", value, "countyid");
            return (Criteria) this;
        }

        public Criteria andCountyidLike(String value) {
            addCriterion("countyId like", value, "countyid");
            return (Criteria) this;
        }

        public Criteria andCountyidNotLike(String value) {
            addCriterion("countyId not like", value, "countyid");
            return (Criteria) this;
        }

        public Criteria andCountyidIn(List<String> values) {
            addCriterion("countyId in", values, "countyid");
            return (Criteria) this;
        }

        public Criteria andCountyidNotIn(List<String> values) {
            addCriterion("countyId not in", values, "countyid");
            return (Criteria) this;
        }

        public Criteria andCountyidBetween(String value1, String value2) {
            addCriterion("countyId between", value1, value2, "countyid");
            return (Criteria) this;
        }

        public Criteria andCountyidNotBetween(String value1, String value2) {
            addCriterion("countyId not between", value1, value2, "countyid");
            return (Criteria) this;
        }

        public Criteria andCountynameIsNull() {
            addCriterion("countyName is null");
            return (Criteria) this;
        }

        public Criteria andCountynameIsNotNull() {
            addCriterion("countyName is not null");
            return (Criteria) this;
        }

        public Criteria andCountynameEqualTo(String value) {
            addCriterion("countyName =", value, "countyname");
            return (Criteria) this;
        }

        public Criteria andCountynameNotEqualTo(String value) {
            addCriterion("countyName <>", value, "countyname");
            return (Criteria) this;
        }

        public Criteria andCountynameGreaterThan(String value) {
            addCriterion("countyName >", value, "countyname");
            return (Criteria) this;
        }

        public Criteria andCountynameGreaterThanOrEqualTo(String value) {
            addCriterion("countyName >=", value, "countyname");
            return (Criteria) this;
        }

        public Criteria andCountynameLessThan(String value) {
            addCriterion("countyName <", value, "countyname");
            return (Criteria) this;
        }

        public Criteria andCountynameLessThanOrEqualTo(String value) {
            addCriterion("countyName <=", value, "countyname");
            return (Criteria) this;
        }

        public Criteria andCountynameLike(String value) {
            addCriterion("countyName like", value, "countyname");
            return (Criteria) this;
        }

        public Criteria andCountynameNotLike(String value) {
            addCriterion("countyName not like", value, "countyname");
            return (Criteria) this;
        }

        public Criteria andCountynameIn(List<String> values) {
            addCriterion("countyName in", values, "countyname");
            return (Criteria) this;
        }

        public Criteria andCountynameNotIn(List<String> values) {
            addCriterion("countyName not in", values, "countyname");
            return (Criteria) this;
        }

        public Criteria andCountynameBetween(String value1, String value2) {
            addCriterion("countyName between", value1, value2, "countyname");
            return (Criteria) this;
        }

        public Criteria andCountynameNotBetween(String value1, String value2) {
            addCriterion("countyName not between", value1, value2, "countyname");
            return (Criteria) this;
        }

        public Criteria andCoefficientIsNull() {
            addCriterion("coefficient is null");
            return (Criteria) this;
        }

        public Criteria andCoefficientIsNotNull() {
            addCriterion("coefficient is not null");
            return (Criteria) this;
        }

        public Criteria andCoefficientEqualTo(BigDecimal value) {
            addCriterion("coefficient =", value, "coefficient");
            return (Criteria) this;
        }

        public Criteria andCoefficientNotEqualTo(BigDecimal value) {
            addCriterion("coefficient <>", value, "coefficient");
            return (Criteria) this;
        }

        public Criteria andCoefficientGreaterThan(BigDecimal value) {
            addCriterion("coefficient >", value, "coefficient");
            return (Criteria) this;
        }

        public Criteria andCoefficientGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("coefficient >=", value, "coefficient");
            return (Criteria) this;
        }

        public Criteria andCoefficientLessThan(BigDecimal value) {
            addCriterion("coefficient <", value, "coefficient");
            return (Criteria) this;
        }

        public Criteria andCoefficientLessThanOrEqualTo(BigDecimal value) {
            addCriterion("coefficient <=", value, "coefficient");
            return (Criteria) this;
        }

        public Criteria andCoefficientIn(List<BigDecimal> values) {
            addCriterion("coefficient in", values, "coefficient");
            return (Criteria) this;
        }

        public Criteria andCoefficientNotIn(List<BigDecimal> values) {
            addCriterion("coefficient not in", values, "coefficient");
            return (Criteria) this;
        }

        public Criteria andCoefficientBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("coefficient between", value1, value2, "coefficient");
            return (Criteria) this;
        }

        public Criteria andCoefficientNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("coefficient not between", value1, value2, "coefficient");
            return (Criteria) this;
        }

        public Criteria andCodeIsNull() {
            addCriterion("code is null");
            return (Criteria) this;
        }

        public Criteria andCodeIsNotNull() {
            addCriterion("code is not null");
            return (Criteria) this;
        }

        public Criteria andCodeEqualTo(String value) {
            addCriterion("code =", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotEqualTo(String value) {
            addCriterion("code <>", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeGreaterThan(String value) {
            addCriterion("code >", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeGreaterThanOrEqualTo(String value) {
            addCriterion("code >=", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLessThan(String value) {
            addCriterion("code <", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLessThanOrEqualTo(String value) {
            addCriterion("code <=", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLike(String value) {
            addCriterion("code like", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotLike(String value) {
            addCriterion("code not like", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeIn(List<String> values) {
            addCriterion("code in", values, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotIn(List<String> values) {
            addCriterion("code not in", values, "code");
            return (Criteria) this;
        }

        public Criteria andCodeBetween(String value1, String value2) {
            addCriterion("code between", value1, value2, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotBetween(String value1, String value2) {
            addCriterion("code not between", value1, value2, "code");
            return (Criteria) this;
        }

        public Criteria andAreaIsNull() {
            addCriterion("area is null");
            return (Criteria) this;
        }

        public Criteria andAreaIsNotNull() {
            addCriterion("area is not null");
            return (Criteria) this;
        }

        public Criteria andAreaEqualTo(String value) {
            addCriterion("area =", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaNotEqualTo(String value) {
            addCriterion("area <>", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaGreaterThan(String value) {
            addCriterion("area >", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaGreaterThanOrEqualTo(String value) {
            addCriterion("area >=", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaLessThan(String value) {
            addCriterion("area <", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaLessThanOrEqualTo(String value) {
            addCriterion("area <=", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaLike(String value) {
            addCriterion("area like", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaNotLike(String value) {
            addCriterion("area not like", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaIn(List<String> values) {
            addCriterion("area in", values, "area");
            return (Criteria) this;
        }

        public Criteria andAreaNotIn(List<String> values) {
            addCriterion("area not in", values, "area");
            return (Criteria) this;
        }

        public Criteria andAreaBetween(String value1, String value2) {
            addCriterion("area between", value1, value2, "area");
            return (Criteria) this;
        }

        public Criteria andAreaNotBetween(String value1, String value2) {
            addCriterion("area not between", value1, value2, "area");
            return (Criteria) this;
        }

        public Criteria andAreaidIsNull() {
            addCriterion("areaId is null");
            return (Criteria) this;
        }

        public Criteria andAreaidIsNotNull() {
            addCriterion("areaId is not null");
            return (Criteria) this;
        }

        public Criteria andAreaidEqualTo(String value) {
            addCriterion("areaId =", value, "areaid");
            return (Criteria) this;
        }

        public Criteria andAreaidNotEqualTo(String value) {
            addCriterion("areaId <>", value, "areaid");
            return (Criteria) this;
        }

        public Criteria andAreaidGreaterThan(String value) {
            addCriterion("areaId >", value, "areaid");
            return (Criteria) this;
        }

        public Criteria andAreaidGreaterThanOrEqualTo(String value) {
            addCriterion("areaId >=", value, "areaid");
            return (Criteria) this;
        }

        public Criteria andAreaidLessThan(String value) {
            addCriterion("areaId <", value, "areaid");
            return (Criteria) this;
        }

        public Criteria andAreaidLessThanOrEqualTo(String value) {
            addCriterion("areaId <=", value, "areaid");
            return (Criteria) this;
        }

        public Criteria andAreaidLike(String value) {
            addCriterion("areaId like", value, "areaid");
            return (Criteria) this;
        }

        public Criteria andAreaidNotLike(String value) {
            addCriterion("areaId not like", value, "areaid");
            return (Criteria) this;
        }

        public Criteria andAreaidIn(List<String> values) {
            addCriterion("areaId in", values, "areaid");
            return (Criteria) this;
        }

        public Criteria andAreaidNotIn(List<String> values) {
            addCriterion("areaId not in", values, "areaid");
            return (Criteria) this;
        }

        public Criteria andAreaidBetween(String value1, String value2) {
            addCriterion("areaId between", value1, value2, "areaid");
            return (Criteria) this;
        }

        public Criteria andAreaidNotBetween(String value1, String value2) {
            addCriterion("areaId not between", value1, value2, "areaid");
            return (Criteria) this;
        }

        public Criteria andCoefficient2IsNull() {
            addCriterion("coefficient2 is null");
            return (Criteria) this;
        }

        public Criteria andCoefficient2IsNotNull() {
            addCriterion("coefficient2 is not null");
            return (Criteria) this;
        }

        public Criteria andCoefficient2EqualTo(BigDecimal value) {
            addCriterion("coefficient2 =", value, "coefficient2");
            return (Criteria) this;
        }

        public Criteria andCoefficient2NotEqualTo(BigDecimal value) {
            addCriterion("coefficient2 <>", value, "coefficient2");
            return (Criteria) this;
        }

        public Criteria andCoefficient2GreaterThan(BigDecimal value) {
            addCriterion("coefficient2 >", value, "coefficient2");
            return (Criteria) this;
        }

        public Criteria andCoefficient2GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("coefficient2 >=", value, "coefficient2");
            return (Criteria) this;
        }

        public Criteria andCoefficient2LessThan(BigDecimal value) {
            addCriterion("coefficient2 <", value, "coefficient2");
            return (Criteria) this;
        }

        public Criteria andCoefficient2LessThanOrEqualTo(BigDecimal value) {
            addCriterion("coefficient2 <=", value, "coefficient2");
            return (Criteria) this;
        }

        public Criteria andCoefficient2In(List<BigDecimal> values) {
            addCriterion("coefficient2 in", values, "coefficient2");
            return (Criteria) this;
        }

        public Criteria andCoefficient2NotIn(List<BigDecimal> values) {
            addCriterion("coefficient2 not in", values, "coefficient2");
            return (Criteria) this;
        }

        public Criteria andCoefficient2Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("coefficient2 between", value1, value2, "coefficient2");
            return (Criteria) this;
        }

        public Criteria andCoefficient2NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("coefficient2 not between", value1, value2, "coefficient2");
            return (Criteria) this;
        }

        public Criteria andManagercodeIsNull() {
            addCriterion("managerCode is null");
            return (Criteria) this;
        }

        public Criteria andManagercodeIsNotNull() {
            addCriterion("managerCode is not null");
            return (Criteria) this;
        }

        public Criteria andManagercodeEqualTo(String value) {
            addCriterion("managerCode =", value, "managercode");
            return (Criteria) this;
        }

        public Criteria andManagercodeNotEqualTo(String value) {
            addCriterion("managerCode <>", value, "managercode");
            return (Criteria) this;
        }

        public Criteria andManagercodeGreaterThan(String value) {
            addCriterion("managerCode >", value, "managercode");
            return (Criteria) this;
        }

        public Criteria andManagercodeGreaterThanOrEqualTo(String value) {
            addCriterion("managerCode >=", value, "managercode");
            return (Criteria) this;
        }

        public Criteria andManagercodeLessThan(String value) {
            addCriterion("managerCode <", value, "managercode");
            return (Criteria) this;
        }

        public Criteria andManagercodeLessThanOrEqualTo(String value) {
            addCriterion("managerCode <=", value, "managercode");
            return (Criteria) this;
        }

        public Criteria andManagercodeLike(String value) {
            addCriterion("managerCode like", value, "managercode");
            return (Criteria) this;
        }

        public Criteria andManagercodeNotLike(String value) {
            addCriterion("managerCode not like", value, "managercode");
            return (Criteria) this;
        }

        public Criteria andManagercodeIn(List<String> values) {
            addCriterion("managerCode in", values, "managercode");
            return (Criteria) this;
        }

        public Criteria andManagercodeNotIn(List<String> values) {
            addCriterion("managerCode not in", values, "managercode");
            return (Criteria) this;
        }

        public Criteria andManagercodeBetween(String value1, String value2) {
            addCriterion("managerCode between", value1, value2, "managercode");
            return (Criteria) this;
        }

        public Criteria andManagercodeNotBetween(String value1, String value2) {
            addCriterion("managerCode not between", value1, value2, "managercode");
            return (Criteria) this;
        }

        public Criteria andManageridIsNull() {
            addCriterion("managerId is null");
            return (Criteria) this;
        }

        public Criteria andManageridIsNotNull() {
            addCriterion("managerId is not null");
            return (Criteria) this;
        }

        public Criteria andManageridEqualTo(Integer value) {
            addCriterion("managerId =", value, "managerid");
            return (Criteria) this;
        }

        public Criteria andManageridNotEqualTo(Integer value) {
            addCriterion("managerId <>", value, "managerid");
            return (Criteria) this;
        }

        public Criteria andManageridGreaterThan(Integer value) {
            addCriterion("managerId >", value, "managerid");
            return (Criteria) this;
        }

        public Criteria andManageridGreaterThanOrEqualTo(Integer value) {
            addCriterion("managerId >=", value, "managerid");
            return (Criteria) this;
        }

        public Criteria andManageridLessThan(Integer value) {
            addCriterion("managerId <", value, "managerid");
            return (Criteria) this;
        }

        public Criteria andManageridLessThanOrEqualTo(Integer value) {
            addCriterion("managerId <=", value, "managerid");
            return (Criteria) this;
        }

        public Criteria andManageridIn(List<Integer> values) {
            addCriterion("managerId in", values, "managerid");
            return (Criteria) this;
        }

        public Criteria andManageridNotIn(List<Integer> values) {
            addCriterion("managerId not in", values, "managerid");
            return (Criteria) this;
        }

        public Criteria andManageridBetween(Integer value1, Integer value2) {
            addCriterion("managerId between", value1, value2, "managerid");
            return (Criteria) this;
        }

        public Criteria andManageridNotBetween(Integer value1, Integer value2) {
            addCriterion("managerId not between", value1, value2, "managerid");
            return (Criteria) this;
        }

        public Criteria andProvinceIsNull() {
            addCriterion("province is null");
            return (Criteria) this;
        }

        public Criteria andProvinceIsNotNull() {
            addCriterion("province is not null");
            return (Criteria) this;
        }

        public Criteria andProvinceEqualTo(String value) {
            addCriterion("province =", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotEqualTo(String value) {
            addCriterion("province <>", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceGreaterThan(String value) {
            addCriterion("province >", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceGreaterThanOrEqualTo(String value) {
            addCriterion("province >=", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLessThan(String value) {
            addCriterion("province <", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLessThanOrEqualTo(String value) {
            addCriterion("province <=", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLike(String value) {
            addCriterion("province like", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotLike(String value) {
            addCriterion("province not like", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceIn(List<String> values) {
            addCriterion("province in", values, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotIn(List<String> values) {
            addCriterion("province not in", values, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceBetween(String value1, String value2) {
            addCriterion("province between", value1, value2, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotBetween(String value1, String value2) {
            addCriterion("province not between", value1, value2, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceidIsNull() {
            addCriterion("provinceId is null");
            return (Criteria) this;
        }

        public Criteria andProvinceidIsNotNull() {
            addCriterion("provinceId is not null");
            return (Criteria) this;
        }

        public Criteria andProvinceidEqualTo(String value) {
            addCriterion("provinceId =", value, "provinceid");
            return (Criteria) this;
        }

        public Criteria andProvinceidNotEqualTo(String value) {
            addCriterion("provinceId <>", value, "provinceid");
            return (Criteria) this;
        }

        public Criteria andProvinceidGreaterThan(String value) {
            addCriterion("provinceId >", value, "provinceid");
            return (Criteria) this;
        }

        public Criteria andProvinceidGreaterThanOrEqualTo(String value) {
            addCriterion("provinceId >=", value, "provinceid");
            return (Criteria) this;
        }

        public Criteria andProvinceidLessThan(String value) {
            addCriterion("provinceId <", value, "provinceid");
            return (Criteria) this;
        }

        public Criteria andProvinceidLessThanOrEqualTo(String value) {
            addCriterion("provinceId <=", value, "provinceid");
            return (Criteria) this;
        }

        public Criteria andProvinceidLike(String value) {
            addCriterion("provinceId like", value, "provinceid");
            return (Criteria) this;
        }

        public Criteria andProvinceidNotLike(String value) {
            addCriterion("provinceId not like", value, "provinceid");
            return (Criteria) this;
        }

        public Criteria andProvinceidIn(List<String> values) {
            addCriterion("provinceId in", values, "provinceid");
            return (Criteria) this;
        }

        public Criteria andProvinceidNotIn(List<String> values) {
            addCriterion("provinceId not in", values, "provinceid");
            return (Criteria) this;
        }

        public Criteria andProvinceidBetween(String value1, String value2) {
            addCriterion("provinceId between", value1, value2, "provinceid");
            return (Criteria) this;
        }

        public Criteria andProvinceidNotBetween(String value1, String value2) {
            addCriterion("provinceId not between", value1, value2, "provinceid");
            return (Criteria) this;
        }

        public Criteria andAidIsNull() {
            addCriterion("aid is null");
            return (Criteria) this;
        }

        public Criteria andAidIsNotNull() {
            addCriterion("aid is not null");
            return (Criteria) this;
        }

        public Criteria andAidEqualTo(Integer value) {
            addCriterion("aid =", value, "aid");
            return (Criteria) this;
        }

        public Criteria andAidNotEqualTo(Integer value) {
            addCriterion("aid <>", value, "aid");
            return (Criteria) this;
        }

        public Criteria andAidGreaterThan(Integer value) {
            addCriterion("aid >", value, "aid");
            return (Criteria) this;
        }

        public Criteria andAidGreaterThanOrEqualTo(Integer value) {
            addCriterion("aid >=", value, "aid");
            return (Criteria) this;
        }

        public Criteria andAidLessThan(Integer value) {
            addCriterion("aid <", value, "aid");
            return (Criteria) this;
        }

        public Criteria andAidLessThanOrEqualTo(Integer value) {
            addCriterion("aid <=", value, "aid");
            return (Criteria) this;
        }

        public Criteria andAidIn(List<Integer> values) {
            addCriterion("aid in", values, "aid");
            return (Criteria) this;
        }

        public Criteria andAidNotIn(List<Integer> values) {
            addCriterion("aid not in", values, "aid");
            return (Criteria) this;
        }

        public Criteria andAidBetween(Integer value1, Integer value2) {
            addCriterion("aid between", value1, value2, "aid");
            return (Criteria) this;
        }

        public Criteria andAidNotBetween(Integer value1, Integer value2) {
            addCriterion("aid not between", value1, value2, "aid");
            return (Criteria) this;
        }

        public Criteria andCidIsNull() {
            addCriterion("cid is null");
            return (Criteria) this;
        }

        public Criteria andCidIsNotNull() {
            addCriterion("cid is not null");
            return (Criteria) this;
        }

        public Criteria andCidEqualTo(Integer value) {
            addCriterion("cid =", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidNotEqualTo(Integer value) {
            addCriterion("cid <>", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidGreaterThan(Integer value) {
            addCriterion("cid >", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidGreaterThanOrEqualTo(Integer value) {
            addCriterion("cid >=", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidLessThan(Integer value) {
            addCriterion("cid <", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidLessThanOrEqualTo(Integer value) {
            addCriterion("cid <=", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidIn(List<Integer> values) {
            addCriterion("cid in", values, "cid");
            return (Criteria) this;
        }

        public Criteria andCidNotIn(List<Integer> values) {
            addCriterion("cid not in", values, "cid");
            return (Criteria) this;
        }

        public Criteria andCidBetween(Integer value1, Integer value2) {
            addCriterion("cid between", value1, value2, "cid");
            return (Criteria) this;
        }

        public Criteria andCidNotBetween(Integer value1, Integer value2) {
            addCriterion("cid not between", value1, value2, "cid");
            return (Criteria) this;
        }

        public Criteria andManagernameIsNull() {
            addCriterion("managerName is null");
            return (Criteria) this;
        }

        public Criteria andManagernameIsNotNull() {
            addCriterion("managerName is not null");
            return (Criteria) this;
        }

        public Criteria andManagernameEqualTo(String value) {
            addCriterion("managerName =", value, "managername");
            return (Criteria) this;
        }

        public Criteria andManagernameNotEqualTo(String value) {
            addCriterion("managerName <>", value, "managername");
            return (Criteria) this;
        }

        public Criteria andManagernameGreaterThan(String value) {
            addCriterion("managerName >", value, "managername");
            return (Criteria) this;
        }

        public Criteria andManagernameGreaterThanOrEqualTo(String value) {
            addCriterion("managerName >=", value, "managername");
            return (Criteria) this;
        }

        public Criteria andManagernameLessThan(String value) {
            addCriterion("managerName <", value, "managername");
            return (Criteria) this;
        }

        public Criteria andManagernameLessThanOrEqualTo(String value) {
            addCriterion("managerName <=", value, "managername");
            return (Criteria) this;
        }

        public Criteria andManagernameLike(String value) {
            addCriterion("managerName like", value, "managername");
            return (Criteria) this;
        }

        public Criteria andManagernameNotLike(String value) {
            addCriterion("managerName not like", value, "managername");
            return (Criteria) this;
        }

        public Criteria andManagernameIn(List<String> values) {
            addCriterion("managerName in", values, "managername");
            return (Criteria) this;
        }

        public Criteria andManagernameNotIn(List<String> values) {
            addCriterion("managerName not in", values, "managername");
            return (Criteria) this;
        }

        public Criteria andManagernameBetween(String value1, String value2) {
            addCriterion("managerName between", value1, value2, "managername");
            return (Criteria) this;
        }

        public Criteria andManagernameNotBetween(String value1, String value2) {
            addCriterion("managerName not between", value1, value2, "managername");
            return (Criteria) this;
        }

        public Criteria andPidIsNull() {
            addCriterion("pid is null");
            return (Criteria) this;
        }

        public Criteria andPidIsNotNull() {
            addCriterion("pid is not null");
            return (Criteria) this;
        }

        public Criteria andPidEqualTo(Integer value) {
            addCriterion("pid =", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidNotEqualTo(Integer value) {
            addCriterion("pid <>", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidGreaterThan(Integer value) {
            addCriterion("pid >", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidGreaterThanOrEqualTo(Integer value) {
            addCriterion("pid >=", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidLessThan(Integer value) {
            addCriterion("pid <", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidLessThanOrEqualTo(Integer value) {
            addCriterion("pid <=", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidIn(List<Integer> values) {
            addCriterion("pid in", values, "pid");
            return (Criteria) this;
        }

        public Criteria andPidNotIn(List<Integer> values) {
            addCriterion("pid not in", values, "pid");
            return (Criteria) this;
        }

        public Criteria andPidBetween(Integer value1, Integer value2) {
            addCriterion("pid between", value1, value2, "pid");
            return (Criteria) this;
        }

        public Criteria andPidNotBetween(Integer value1, Integer value2) {
            addCriterion("pid not between", value1, value2, "pid");
            return (Criteria) this;
        }

        public Criteria andTidIsNull() {
            addCriterion("tid is null");
            return (Criteria) this;
        }

        public Criteria andTidIsNotNull() {
            addCriterion("tid is not null");
            return (Criteria) this;
        }

        public Criteria andTidEqualTo(Integer value) {
            addCriterion("tid =", value, "tid");
            return (Criteria) this;
        }

        public Criteria andTidNotEqualTo(Integer value) {
            addCriterion("tid <>", value, "tid");
            return (Criteria) this;
        }

        public Criteria andTidGreaterThan(Integer value) {
            addCriterion("tid >", value, "tid");
            return (Criteria) this;
        }

        public Criteria andTidGreaterThanOrEqualTo(Integer value) {
            addCriterion("tid >=", value, "tid");
            return (Criteria) this;
        }

        public Criteria andTidLessThan(Integer value) {
            addCriterion("tid <", value, "tid");
            return (Criteria) this;
        }

        public Criteria andTidLessThanOrEqualTo(Integer value) {
            addCriterion("tid <=", value, "tid");
            return (Criteria) this;
        }

        public Criteria andTidIn(List<Integer> values) {
            addCriterion("tid in", values, "tid");
            return (Criteria) this;
        }

        public Criteria andTidNotIn(List<Integer> values) {
            addCriterion("tid not in", values, "tid");
            return (Criteria) this;
        }

        public Criteria andTidBetween(Integer value1, Integer value2) {
            addCriterion("tid between", value1, value2, "tid");
            return (Criteria) this;
        }

        public Criteria andTidNotBetween(Integer value1, Integer value2) {
            addCriterion("tid not between", value1, value2, "tid");
            return (Criteria) this;
        }

        public Criteria andIshaveupIsNull() {
            addCriterion("ishaveup is null");
            return (Criteria) this;
        }

        public Criteria andIshaveupIsNotNull() {
            addCriterion("ishaveup is not null");
            return (Criteria) this;
        }

        public Criteria andIshaveupEqualTo(Integer value) {
            addCriterion("ishaveup =", value, "ishaveup");
            return (Criteria) this;
        }

        public Criteria andIshaveupNotEqualTo(Integer value) {
            addCriterion("ishaveup <>", value, "ishaveup");
            return (Criteria) this;
        }

        public Criteria andIshaveupGreaterThan(Integer value) {
            addCriterion("ishaveup >", value, "ishaveup");
            return (Criteria) this;
        }

        public Criteria andIshaveupGreaterThanOrEqualTo(Integer value) {
            addCriterion("ishaveup >=", value, "ishaveup");
            return (Criteria) this;
        }

        public Criteria andIshaveupLessThan(Integer value) {
            addCriterion("ishaveup <", value, "ishaveup");
            return (Criteria) this;
        }

        public Criteria andIshaveupLessThanOrEqualTo(Integer value) {
            addCriterion("ishaveup <=", value, "ishaveup");
            return (Criteria) this;
        }

        public Criteria andIshaveupIn(List<Integer> values) {
            addCriterion("ishaveup in", values, "ishaveup");
            return (Criteria) this;
        }

        public Criteria andIshaveupNotIn(List<Integer> values) {
            addCriterion("ishaveup not in", values, "ishaveup");
            return (Criteria) this;
        }

        public Criteria andIshaveupBetween(Integer value1, Integer value2) {
            addCriterion("ishaveup between", value1, value2, "ishaveup");
            return (Criteria) this;
        }

        public Criteria andIshaveupNotBetween(Integer value1, Integer value2) {
            addCriterion("ishaveup not between", value1, value2, "ishaveup");
            return (Criteria) this;
        }

        public Criteria andCompanyNameIsNull() {
            addCriterion("company_name is null");
            return (Criteria) this;
        }

        public Criteria andCompanyNameIsNotNull() {
            addCriterion("company_name is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyNameEqualTo(String value) {
            addCriterion("company_name =", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotEqualTo(String value) {
            addCriterion("company_name <>", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameGreaterThan(String value) {
            addCriterion("company_name >", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameGreaterThanOrEqualTo(String value) {
            addCriterion("company_name >=", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameLessThan(String value) {
            addCriterion("company_name <", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameLessThanOrEqualTo(String value) {
            addCriterion("company_name <=", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameLike(String value) {
            addCriterion("company_name like", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotLike(String value) {
            addCriterion("company_name not like", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameIn(List<String> values) {
            addCriterion("company_name in", values, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotIn(List<String> values) {
            addCriterion("company_name not in", values, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameBetween(String value1, String value2) {
            addCriterion("company_name between", value1, value2, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotBetween(String value1, String value2) {
            addCriterion("company_name not between", value1, value2, "companyName");
            return (Criteria) this;
        }

        public Criteria andLegalNameIsNull() {
            addCriterion("legal_name is null");
            return (Criteria) this;
        }

        public Criteria andLegalNameIsNotNull() {
            addCriterion("legal_name is not null");
            return (Criteria) this;
        }

        public Criteria andLegalNameEqualTo(String value) {
            addCriterion("legal_name =", value, "legalName");
            return (Criteria) this;
        }

        public Criteria andLegalNameNotEqualTo(String value) {
            addCriterion("legal_name <>", value, "legalName");
            return (Criteria) this;
        }

        public Criteria andLegalNameGreaterThan(String value) {
            addCriterion("legal_name >", value, "legalName");
            return (Criteria) this;
        }

        public Criteria andLegalNameGreaterThanOrEqualTo(String value) {
            addCriterion("legal_name >=", value, "legalName");
            return (Criteria) this;
        }

        public Criteria andLegalNameLessThan(String value) {
            addCriterion("legal_name <", value, "legalName");
            return (Criteria) this;
        }

        public Criteria andLegalNameLessThanOrEqualTo(String value) {
            addCriterion("legal_name <=", value, "legalName");
            return (Criteria) this;
        }

        public Criteria andLegalNameLike(String value) {
            addCriterion("legal_name like", value, "legalName");
            return (Criteria) this;
        }

        public Criteria andLegalNameNotLike(String value) {
            addCriterion("legal_name not like", value, "legalName");
            return (Criteria) this;
        }

        public Criteria andLegalNameIn(List<String> values) {
            addCriterion("legal_name in", values, "legalName");
            return (Criteria) this;
        }

        public Criteria andLegalNameNotIn(List<String> values) {
            addCriterion("legal_name not in", values, "legalName");
            return (Criteria) this;
        }

        public Criteria andLegalNameBetween(String value1, String value2) {
            addCriterion("legal_name between", value1, value2, "legalName");
            return (Criteria) this;
        }

        public Criteria andLegalNameNotBetween(String value1, String value2) {
            addCriterion("legal_name not between", value1, value2, "legalName");
            return (Criteria) this;
        }

        public Criteria andLegalMobileIsNull() {
            addCriterion("legal_mobile is null");
            return (Criteria) this;
        }

        public Criteria andLegalMobileIsNotNull() {
            addCriterion("legal_mobile is not null");
            return (Criteria) this;
        }

        public Criteria andLegalMobileEqualTo(String value) {
            addCriterion("legal_mobile =", value, "legalMobile");
            return (Criteria) this;
        }

        public Criteria andLegalMobileNotEqualTo(String value) {
            addCriterion("legal_mobile <>", value, "legalMobile");
            return (Criteria) this;
        }

        public Criteria andLegalMobileGreaterThan(String value) {
            addCriterion("legal_mobile >", value, "legalMobile");
            return (Criteria) this;
        }

        public Criteria andLegalMobileGreaterThanOrEqualTo(String value) {
            addCriterion("legal_mobile >=", value, "legalMobile");
            return (Criteria) this;
        }

        public Criteria andLegalMobileLessThan(String value) {
            addCriterion("legal_mobile <", value, "legalMobile");
            return (Criteria) this;
        }

        public Criteria andLegalMobileLessThanOrEqualTo(String value) {
            addCriterion("legal_mobile <=", value, "legalMobile");
            return (Criteria) this;
        }

        public Criteria andLegalMobileLike(String value) {
            addCriterion("legal_mobile like", value, "legalMobile");
            return (Criteria) this;
        }

        public Criteria andLegalMobileNotLike(String value) {
            addCriterion("legal_mobile not like", value, "legalMobile");
            return (Criteria) this;
        }

        public Criteria andLegalMobileIn(List<String> values) {
            addCriterion("legal_mobile in", values, "legalMobile");
            return (Criteria) this;
        }

        public Criteria andLegalMobileNotIn(List<String> values) {
            addCriterion("legal_mobile not in", values, "legalMobile");
            return (Criteria) this;
        }

        public Criteria andLegalMobileBetween(String value1, String value2) {
            addCriterion("legal_mobile between", value1, value2, "legalMobile");
            return (Criteria) this;
        }

        public Criteria andLegalMobileNotBetween(String value1, String value2) {
            addCriterion("legal_mobile not between", value1, value2, "legalMobile");
            return (Criteria) this;
        }

        public Criteria andLegalIdnumberIsNull() {
            addCriterion("legal_idNumber is null");
            return (Criteria) this;
        }

        public Criteria andLegalIdnumberIsNotNull() {
            addCriterion("legal_idNumber is not null");
            return (Criteria) this;
        }

        public Criteria andLegalIdnumberEqualTo(String value) {
            addCriterion("legal_idNumber =", value, "legalIdnumber");
            return (Criteria) this;
        }

        public Criteria andLegalIdnumberNotEqualTo(String value) {
            addCriterion("legal_idNumber <>", value, "legalIdnumber");
            return (Criteria) this;
        }

        public Criteria andLegalIdnumberGreaterThan(String value) {
            addCriterion("legal_idNumber >", value, "legalIdnumber");
            return (Criteria) this;
        }

        public Criteria andLegalIdnumberGreaterThanOrEqualTo(String value) {
            addCriterion("legal_idNumber >=", value, "legalIdnumber");
            return (Criteria) this;
        }

        public Criteria andLegalIdnumberLessThan(String value) {
            addCriterion("legal_idNumber <", value, "legalIdnumber");
            return (Criteria) this;
        }

        public Criteria andLegalIdnumberLessThanOrEqualTo(String value) {
            addCriterion("legal_idNumber <=", value, "legalIdnumber");
            return (Criteria) this;
        }

        public Criteria andLegalIdnumberLike(String value) {
            addCriterion("legal_idNumber like", value, "legalIdnumber");
            return (Criteria) this;
        }

        public Criteria andLegalIdnumberNotLike(String value) {
            addCriterion("legal_idNumber not like", value, "legalIdnumber");
            return (Criteria) this;
        }

        public Criteria andLegalIdnumberIn(List<String> values) {
            addCriterion("legal_idNumber in", values, "legalIdnumber");
            return (Criteria) this;
        }

        public Criteria andLegalIdnumberNotIn(List<String> values) {
            addCriterion("legal_idNumber not in", values, "legalIdnumber");
            return (Criteria) this;
        }

        public Criteria andLegalIdnumberBetween(String value1, String value2) {
            addCriterion("legal_idNumber between", value1, value2, "legalIdnumber");
            return (Criteria) this;
        }

        public Criteria andLegalIdnumberNotBetween(String value1, String value2) {
            addCriterion("legal_idNumber not between", value1, value2, "legalIdnumber");
            return (Criteria) this;
        }

        public Criteria andLegalIdPositiveLoadIsNull() {
            addCriterion("legal_id_positive_load is null");
            return (Criteria) this;
        }

        public Criteria andLegalIdPositiveLoadIsNotNull() {
            addCriterion("legal_id_positive_load is not null");
            return (Criteria) this;
        }

        public Criteria andLegalIdPositiveLoadEqualTo(String value) {
            addCriterion("legal_id_positive_load =", value, "legalIdPositiveLoad");
            return (Criteria) this;
        }

        public Criteria andLegalIdPositiveLoadNotEqualTo(String value) {
            addCriterion("legal_id_positive_load <>", value, "legalIdPositiveLoad");
            return (Criteria) this;
        }

        public Criteria andLegalIdPositiveLoadGreaterThan(String value) {
            addCriterion("legal_id_positive_load >", value, "legalIdPositiveLoad");
            return (Criteria) this;
        }

        public Criteria andLegalIdPositiveLoadGreaterThanOrEqualTo(String value) {
            addCriterion("legal_id_positive_load >=", value, "legalIdPositiveLoad");
            return (Criteria) this;
        }

        public Criteria andLegalIdPositiveLoadLessThan(String value) {
            addCriterion("legal_id_positive_load <", value, "legalIdPositiveLoad");
            return (Criteria) this;
        }

        public Criteria andLegalIdPositiveLoadLessThanOrEqualTo(String value) {
            addCriterion("legal_id_positive_load <=", value, "legalIdPositiveLoad");
            return (Criteria) this;
        }

        public Criteria andLegalIdPositiveLoadLike(String value) {
            addCriterion("legal_id_positive_load like", value, "legalIdPositiveLoad");
            return (Criteria) this;
        }

        public Criteria andLegalIdPositiveLoadNotLike(String value) {
            addCriterion("legal_id_positive_load not like", value, "legalIdPositiveLoad");
            return (Criteria) this;
        }

        public Criteria andLegalIdPositiveLoadIn(List<String> values) {
            addCriterion("legal_id_positive_load in", values, "legalIdPositiveLoad");
            return (Criteria) this;
        }

        public Criteria andLegalIdPositiveLoadNotIn(List<String> values) {
            addCriterion("legal_id_positive_load not in", values, "legalIdPositiveLoad");
            return (Criteria) this;
        }

        public Criteria andLegalIdPositiveLoadBetween(String value1, String value2) {
            addCriterion("legal_id_positive_load between", value1, value2, "legalIdPositiveLoad");
            return (Criteria) this;
        }

        public Criteria andLegalIdPositiveLoadNotBetween(String value1, String value2) {
            addCriterion("legal_id_positive_load not between", value1, value2, "legalIdPositiveLoad");
            return (Criteria) this;
        }

        public Criteria andLegalIdNegativeLoadIsNull() {
            addCriterion("legal_id_negative_load is null");
            return (Criteria) this;
        }

        public Criteria andLegalIdNegativeLoadIsNotNull() {
            addCriterion("legal_id_negative_load is not null");
            return (Criteria) this;
        }

        public Criteria andLegalIdNegativeLoadEqualTo(String value) {
            addCriterion("legal_id_negative_load =", value, "legalIdNegativeLoad");
            return (Criteria) this;
        }

        public Criteria andLegalIdNegativeLoadNotEqualTo(String value) {
            addCriterion("legal_id_negative_load <>", value, "legalIdNegativeLoad");
            return (Criteria) this;
        }

        public Criteria andLegalIdNegativeLoadGreaterThan(String value) {
            addCriterion("legal_id_negative_load >", value, "legalIdNegativeLoad");
            return (Criteria) this;
        }

        public Criteria andLegalIdNegativeLoadGreaterThanOrEqualTo(String value) {
            addCriterion("legal_id_negative_load >=", value, "legalIdNegativeLoad");
            return (Criteria) this;
        }

        public Criteria andLegalIdNegativeLoadLessThan(String value) {
            addCriterion("legal_id_negative_load <", value, "legalIdNegativeLoad");
            return (Criteria) this;
        }

        public Criteria andLegalIdNegativeLoadLessThanOrEqualTo(String value) {
            addCriterion("legal_id_negative_load <=", value, "legalIdNegativeLoad");
            return (Criteria) this;
        }

        public Criteria andLegalIdNegativeLoadLike(String value) {
            addCriterion("legal_id_negative_load like", value, "legalIdNegativeLoad");
            return (Criteria) this;
        }

        public Criteria andLegalIdNegativeLoadNotLike(String value) {
            addCriterion("legal_id_negative_load not like", value, "legalIdNegativeLoad");
            return (Criteria) this;
        }

        public Criteria andLegalIdNegativeLoadIn(List<String> values) {
            addCriterion("legal_id_negative_load in", values, "legalIdNegativeLoad");
            return (Criteria) this;
        }

        public Criteria andLegalIdNegativeLoadNotIn(List<String> values) {
            addCriterion("legal_id_negative_load not in", values, "legalIdNegativeLoad");
            return (Criteria) this;
        }

        public Criteria andLegalIdNegativeLoadBetween(String value1, String value2) {
            addCriterion("legal_id_negative_load between", value1, value2, "legalIdNegativeLoad");
            return (Criteria) this;
        }

        public Criteria andLegalIdNegativeLoadNotBetween(String value1, String value2) {
            addCriterion("legal_id_negative_load not between", value1, value2, "legalIdNegativeLoad");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeLoadIsNull() {
            addCriterion("unified_social_credit_code_load is null");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeLoadIsNotNull() {
            addCriterion("unified_social_credit_code_load is not null");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeLoadEqualTo(String value) {
            addCriterion("unified_social_credit_code_load =", value, "unifiedSocialCreditCodeLoad");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeLoadNotEqualTo(String value) {
            addCriterion("unified_social_credit_code_load <>", value, "unifiedSocialCreditCodeLoad");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeLoadGreaterThan(String value) {
            addCriterion("unified_social_credit_code_load >", value, "unifiedSocialCreditCodeLoad");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeLoadGreaterThanOrEqualTo(String value) {
            addCriterion("unified_social_credit_code_load >=", value, "unifiedSocialCreditCodeLoad");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeLoadLessThan(String value) {
            addCriterion("unified_social_credit_code_load <", value, "unifiedSocialCreditCodeLoad");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeLoadLessThanOrEqualTo(String value) {
            addCriterion("unified_social_credit_code_load <=", value, "unifiedSocialCreditCodeLoad");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeLoadLike(String value) {
            addCriterion("unified_social_credit_code_load like", value, "unifiedSocialCreditCodeLoad");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeLoadNotLike(String value) {
            addCriterion("unified_social_credit_code_load not like", value, "unifiedSocialCreditCodeLoad");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeLoadIn(List<String> values) {
            addCriterion("unified_social_credit_code_load in", values, "unifiedSocialCreditCodeLoad");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeLoadNotIn(List<String> values) {
            addCriterion("unified_social_credit_code_load not in", values, "unifiedSocialCreditCodeLoad");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeLoadBetween(String value1, String value2) {
            addCriterion("unified_social_credit_code_load between", value1, value2, "unifiedSocialCreditCodeLoad");
            return (Criteria) this;
        }

        public Criteria andUnifiedSocialCreditCodeLoadNotBetween(String value1, String value2) {
            addCriterion("unified_social_credit_code_load not between", value1, value2, "unifiedSocialCreditCodeLoad");
            return (Criteria) this;
        }

        public Criteria andAdminNameIsNull() {
            addCriterion("admin_name is null");
            return (Criteria) this;
        }

        public Criteria andAdminNameIsNotNull() {
            addCriterion("admin_name is not null");
            return (Criteria) this;
        }

        public Criteria andAdminNameEqualTo(String value) {
            addCriterion("admin_name =", value, "adminName");
            return (Criteria) this;
        }

        public Criteria andAdminNameNotEqualTo(String value) {
            addCriterion("admin_name <>", value, "adminName");
            return (Criteria) this;
        }

        public Criteria andAdminNameGreaterThan(String value) {
            addCriterion("admin_name >", value, "adminName");
            return (Criteria) this;
        }

        public Criteria andAdminNameGreaterThanOrEqualTo(String value) {
            addCriterion("admin_name >=", value, "adminName");
            return (Criteria) this;
        }

        public Criteria andAdminNameLessThan(String value) {
            addCriterion("admin_name <", value, "adminName");
            return (Criteria) this;
        }

        public Criteria andAdminNameLessThanOrEqualTo(String value) {
            addCriterion("admin_name <=", value, "adminName");
            return (Criteria) this;
        }

        public Criteria andAdminNameLike(String value) {
            addCriterion("admin_name like", value, "adminName");
            return (Criteria) this;
        }

        public Criteria andAdminNameNotLike(String value) {
            addCriterion("admin_name not like", value, "adminName");
            return (Criteria) this;
        }

        public Criteria andAdminNameIn(List<String> values) {
            addCriterion("admin_name in", values, "adminName");
            return (Criteria) this;
        }

        public Criteria andAdminNameNotIn(List<String> values) {
            addCriterion("admin_name not in", values, "adminName");
            return (Criteria) this;
        }

        public Criteria andAdminNameBetween(String value1, String value2) {
            addCriterion("admin_name between", value1, value2, "adminName");
            return (Criteria) this;
        }

        public Criteria andAdminNameNotBetween(String value1, String value2) {
            addCriterion("admin_name not between", value1, value2, "adminName");
            return (Criteria) this;
        }

        public Criteria andAdminMobileIsNull() {
            addCriterion("admin_mobile is null");
            return (Criteria) this;
        }

        public Criteria andAdminMobileIsNotNull() {
            addCriterion("admin_mobile is not null");
            return (Criteria) this;
        }

        public Criteria andAdminMobileEqualTo(String value) {
            addCriterion("admin_mobile =", value, "adminMobile");
            return (Criteria) this;
        }

        public Criteria andAdminMobileNotEqualTo(String value) {
            addCriterion("admin_mobile <>", value, "adminMobile");
            return (Criteria) this;
        }

        public Criteria andAdminMobileGreaterThan(String value) {
            addCriterion("admin_mobile >", value, "adminMobile");
            return (Criteria) this;
        }

        public Criteria andAdminMobileGreaterThanOrEqualTo(String value) {
            addCriterion("admin_mobile >=", value, "adminMobile");
            return (Criteria) this;
        }

        public Criteria andAdminMobileLessThan(String value) {
            addCriterion("admin_mobile <", value, "adminMobile");
            return (Criteria) this;
        }

        public Criteria andAdminMobileLessThanOrEqualTo(String value) {
            addCriterion("admin_mobile <=", value, "adminMobile");
            return (Criteria) this;
        }

        public Criteria andAdminMobileLike(String value) {
            addCriterion("admin_mobile like", value, "adminMobile");
            return (Criteria) this;
        }

        public Criteria andAdminMobileNotLike(String value) {
            addCriterion("admin_mobile not like", value, "adminMobile");
            return (Criteria) this;
        }

        public Criteria andAdminMobileIn(List<String> values) {
            addCriterion("admin_mobile in", values, "adminMobile");
            return (Criteria) this;
        }

        public Criteria andAdminMobileNotIn(List<String> values) {
            addCriterion("admin_mobile not in", values, "adminMobile");
            return (Criteria) this;
        }

        public Criteria andAdminMobileBetween(String value1, String value2) {
            addCriterion("admin_mobile between", value1, value2, "adminMobile");
            return (Criteria) this;
        }

        public Criteria andAdminMobileNotBetween(String value1, String value2) {
            addCriterion("admin_mobile not between", value1, value2, "adminMobile");
            return (Criteria) this;
        }

        public Criteria andAdminIdnumberIsNull() {
            addCriterion("admin_idNumber is null");
            return (Criteria) this;
        }

        public Criteria andAdminIdnumberIsNotNull() {
            addCriterion("admin_idNumber is not null");
            return (Criteria) this;
        }

        public Criteria andAdminIdnumberEqualTo(String value) {
            addCriterion("admin_idNumber =", value, "adminIdnumber");
            return (Criteria) this;
        }

        public Criteria andAdminIdnumberNotEqualTo(String value) {
            addCriterion("admin_idNumber <>", value, "adminIdnumber");
            return (Criteria) this;
        }

        public Criteria andAdminIdnumberGreaterThan(String value) {
            addCriterion("admin_idNumber >", value, "adminIdnumber");
            return (Criteria) this;
        }

        public Criteria andAdminIdnumberGreaterThanOrEqualTo(String value) {
            addCriterion("admin_idNumber >=", value, "adminIdnumber");
            return (Criteria) this;
        }

        public Criteria andAdminIdnumberLessThan(String value) {
            addCriterion("admin_idNumber <", value, "adminIdnumber");
            return (Criteria) this;
        }

        public Criteria andAdminIdnumberLessThanOrEqualTo(String value) {
            addCriterion("admin_idNumber <=", value, "adminIdnumber");
            return (Criteria) this;
        }

        public Criteria andAdminIdnumberLike(String value) {
            addCriterion("admin_idNumber like", value, "adminIdnumber");
            return (Criteria) this;
        }

        public Criteria andAdminIdnumberNotLike(String value) {
            addCriterion("admin_idNumber not like", value, "adminIdnumber");
            return (Criteria) this;
        }

        public Criteria andAdminIdnumberIn(List<String> values) {
            addCriterion("admin_idNumber in", values, "adminIdnumber");
            return (Criteria) this;
        }

        public Criteria andAdminIdnumberNotIn(List<String> values) {
            addCriterion("admin_idNumber not in", values, "adminIdnumber");
            return (Criteria) this;
        }

        public Criteria andAdminIdnumberBetween(String value1, String value2) {
            addCriterion("admin_idNumber between", value1, value2, "adminIdnumber");
            return (Criteria) this;
        }

        public Criteria andAdminIdnumberNotBetween(String value1, String value2) {
            addCriterion("admin_idNumber not between", value1, value2, "adminIdnumber");
            return (Criteria) this;
        }

        public Criteria andAdminIdPositiveLoadIsNull() {
            addCriterion("admin_id_positive_load is null");
            return (Criteria) this;
        }

        public Criteria andAdminIdPositiveLoadIsNotNull() {
            addCriterion("admin_id_positive_load is not null");
            return (Criteria) this;
        }

        public Criteria andAdminIdPositiveLoadEqualTo(String value) {
            addCriterion("admin_id_positive_load =", value, "adminIdPositiveLoad");
            return (Criteria) this;
        }

        public Criteria andAdminIdPositiveLoadNotEqualTo(String value) {
            addCriterion("admin_id_positive_load <>", value, "adminIdPositiveLoad");
            return (Criteria) this;
        }

        public Criteria andAdminIdPositiveLoadGreaterThan(String value) {
            addCriterion("admin_id_positive_load >", value, "adminIdPositiveLoad");
            return (Criteria) this;
        }

        public Criteria andAdminIdPositiveLoadGreaterThanOrEqualTo(String value) {
            addCriterion("admin_id_positive_load >=", value, "adminIdPositiveLoad");
            return (Criteria) this;
        }

        public Criteria andAdminIdPositiveLoadLessThan(String value) {
            addCriterion("admin_id_positive_load <", value, "adminIdPositiveLoad");
            return (Criteria) this;
        }

        public Criteria andAdminIdPositiveLoadLessThanOrEqualTo(String value) {
            addCriterion("admin_id_positive_load <=", value, "adminIdPositiveLoad");
            return (Criteria) this;
        }

        public Criteria andAdminIdPositiveLoadLike(String value) {
            addCriterion("admin_id_positive_load like", value, "adminIdPositiveLoad");
            return (Criteria) this;
        }

        public Criteria andAdminIdPositiveLoadNotLike(String value) {
            addCriterion("admin_id_positive_load not like", value, "adminIdPositiveLoad");
            return (Criteria) this;
        }

        public Criteria andAdminIdPositiveLoadIn(List<String> values) {
            addCriterion("admin_id_positive_load in", values, "adminIdPositiveLoad");
            return (Criteria) this;
        }

        public Criteria andAdminIdPositiveLoadNotIn(List<String> values) {
            addCriterion("admin_id_positive_load not in", values, "adminIdPositiveLoad");
            return (Criteria) this;
        }

        public Criteria andAdminIdPositiveLoadBetween(String value1, String value2) {
            addCriterion("admin_id_positive_load between", value1, value2, "adminIdPositiveLoad");
            return (Criteria) this;
        }

        public Criteria andAdminIdPositiveLoadNotBetween(String value1, String value2) {
            addCriterion("admin_id_positive_load not between", value1, value2, "adminIdPositiveLoad");
            return (Criteria) this;
        }

        public Criteria andAdminIdNegativeLoadIsNull() {
            addCriterion("admin_id_negative_load is null");
            return (Criteria) this;
        }

        public Criteria andAdminIdNegativeLoadIsNotNull() {
            addCriterion("admin_id_negative_load is not null");
            return (Criteria) this;
        }

        public Criteria andAdminIdNegativeLoadEqualTo(String value) {
            addCriterion("admin_id_negative_load =", value, "adminIdNegativeLoad");
            return (Criteria) this;
        }

        public Criteria andAdminIdNegativeLoadNotEqualTo(String value) {
            addCriterion("admin_id_negative_load <>", value, "adminIdNegativeLoad");
            return (Criteria) this;
        }

        public Criteria andAdminIdNegativeLoadGreaterThan(String value) {
            addCriterion("admin_id_negative_load >", value, "adminIdNegativeLoad");
            return (Criteria) this;
        }

        public Criteria andAdminIdNegativeLoadGreaterThanOrEqualTo(String value) {
            addCriterion("admin_id_negative_load >=", value, "adminIdNegativeLoad");
            return (Criteria) this;
        }

        public Criteria andAdminIdNegativeLoadLessThan(String value) {
            addCriterion("admin_id_negative_load <", value, "adminIdNegativeLoad");
            return (Criteria) this;
        }

        public Criteria andAdminIdNegativeLoadLessThanOrEqualTo(String value) {
            addCriterion("admin_id_negative_load <=", value, "adminIdNegativeLoad");
            return (Criteria) this;
        }

        public Criteria andAdminIdNegativeLoadLike(String value) {
            addCriterion("admin_id_negative_load like", value, "adminIdNegativeLoad");
            return (Criteria) this;
        }

        public Criteria andAdminIdNegativeLoadNotLike(String value) {
            addCriterion("admin_id_negative_load not like", value, "adminIdNegativeLoad");
            return (Criteria) this;
        }

        public Criteria andAdminIdNegativeLoadIn(List<String> values) {
            addCriterion("admin_id_negative_load in", values, "adminIdNegativeLoad");
            return (Criteria) this;
        }

        public Criteria andAdminIdNegativeLoadNotIn(List<String> values) {
            addCriterion("admin_id_negative_load not in", values, "adminIdNegativeLoad");
            return (Criteria) this;
        }

        public Criteria andAdminIdNegativeLoadBetween(String value1, String value2) {
            addCriterion("admin_id_negative_load between", value1, value2, "adminIdNegativeLoad");
            return (Criteria) this;
        }

        public Criteria andAdminIdNegativeLoadNotBetween(String value1, String value2) {
            addCriterion("admin_id_negative_load not between", value1, value2, "adminIdNegativeLoad");
            return (Criteria) this;
        }

        public Criteria andPublicAccountsNameIsNull() {
            addCriterion("public_accounts_name is null");
            return (Criteria) this;
        }

        public Criteria andPublicAccountsNameIsNotNull() {
            addCriterion("public_accounts_name is not null");
            return (Criteria) this;
        }

        public Criteria andPublicAccountsNameEqualTo(String value) {
            addCriterion("public_accounts_name =", value, "publicAccountsName");
            return (Criteria) this;
        }

        public Criteria andPublicAccountsNameNotEqualTo(String value) {
            addCriterion("public_accounts_name <>", value, "publicAccountsName");
            return (Criteria) this;
        }

        public Criteria andPublicAccountsNameGreaterThan(String value) {
            addCriterion("public_accounts_name >", value, "publicAccountsName");
            return (Criteria) this;
        }

        public Criteria andPublicAccountsNameGreaterThanOrEqualTo(String value) {
            addCriterion("public_accounts_name >=", value, "publicAccountsName");
            return (Criteria) this;
        }

        public Criteria andPublicAccountsNameLessThan(String value) {
            addCriterion("public_accounts_name <", value, "publicAccountsName");
            return (Criteria) this;
        }

        public Criteria andPublicAccountsNameLessThanOrEqualTo(String value) {
            addCriterion("public_accounts_name <=", value, "publicAccountsName");
            return (Criteria) this;
        }

        public Criteria andPublicAccountsNameLike(String value) {
            addCriterion("public_accounts_name like", value, "publicAccountsName");
            return (Criteria) this;
        }

        public Criteria andPublicAccountsNameNotLike(String value) {
            addCriterion("public_accounts_name not like", value, "publicAccountsName");
            return (Criteria) this;
        }

        public Criteria andPublicAccountsNameIn(List<String> values) {
            addCriterion("public_accounts_name in", values, "publicAccountsName");
            return (Criteria) this;
        }

        public Criteria andPublicAccountsNameNotIn(List<String> values) {
            addCriterion("public_accounts_name not in", values, "publicAccountsName");
            return (Criteria) this;
        }

        public Criteria andPublicAccountsNameBetween(String value1, String value2) {
            addCriterion("public_accounts_name between", value1, value2, "publicAccountsName");
            return (Criteria) this;
        }

        public Criteria andPublicAccountsNameNotBetween(String value1, String value2) {
            addCriterion("public_accounts_name not between", value1, value2, "publicAccountsName");
            return (Criteria) this;
        }

        public Criteria andBankAccountIsNull() {
            addCriterion("bank_account is null");
            return (Criteria) this;
        }

        public Criteria andBankAccountIsNotNull() {
            addCriterion("bank_account is not null");
            return (Criteria) this;
        }

        public Criteria andBankAccountEqualTo(String value) {
            addCriterion("bank_account =", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountNotEqualTo(String value) {
            addCriterion("bank_account <>", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountGreaterThan(String value) {
            addCriterion("bank_account >", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountGreaterThanOrEqualTo(String value) {
            addCriterion("bank_account >=", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountLessThan(String value) {
            addCriterion("bank_account <", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountLessThanOrEqualTo(String value) {
            addCriterion("bank_account <=", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountLike(String value) {
            addCriterion("bank_account like", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountNotLike(String value) {
            addCriterion("bank_account not like", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountIn(List<String> values) {
            addCriterion("bank_account in", values, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountNotIn(List<String> values) {
            addCriterion("bank_account not in", values, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountBetween(String value1, String value2) {
            addCriterion("bank_account between", value1, value2, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountNotBetween(String value1, String value2) {
            addCriterion("bank_account not between", value1, value2, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andAccountBankIsNull() {
            addCriterion("account_bank is null");
            return (Criteria) this;
        }

        public Criteria andAccountBankIsNotNull() {
            addCriterion("account_bank is not null");
            return (Criteria) this;
        }

        public Criteria andAccountBankEqualTo(String value) {
            addCriterion("account_bank =", value, "accountBank");
            return (Criteria) this;
        }

        public Criteria andAccountBankNotEqualTo(String value) {
            addCriterion("account_bank <>", value, "accountBank");
            return (Criteria) this;
        }

        public Criteria andAccountBankGreaterThan(String value) {
            addCriterion("account_bank >", value, "accountBank");
            return (Criteria) this;
        }

        public Criteria andAccountBankGreaterThanOrEqualTo(String value) {
            addCriterion("account_bank >=", value, "accountBank");
            return (Criteria) this;
        }

        public Criteria andAccountBankLessThan(String value) {
            addCriterion("account_bank <", value, "accountBank");
            return (Criteria) this;
        }

        public Criteria andAccountBankLessThanOrEqualTo(String value) {
            addCriterion("account_bank <=", value, "accountBank");
            return (Criteria) this;
        }

        public Criteria andAccountBankLike(String value) {
            addCriterion("account_bank like", value, "accountBank");
            return (Criteria) this;
        }

        public Criteria andAccountBankNotLike(String value) {
            addCriterion("account_bank not like", value, "accountBank");
            return (Criteria) this;
        }

        public Criteria andAccountBankIn(List<String> values) {
            addCriterion("account_bank in", values, "accountBank");
            return (Criteria) this;
        }

        public Criteria andAccountBankNotIn(List<String> values) {
            addCriterion("account_bank not in", values, "accountBank");
            return (Criteria) this;
        }

        public Criteria andAccountBankBetween(String value1, String value2) {
            addCriterion("account_bank between", value1, value2, "accountBank");
            return (Criteria) this;
        }

        public Criteria andAccountBankNotBetween(String value1, String value2) {
            addCriterion("account_bank not between", value1, value2, "accountBank");
            return (Criteria) this;
        }

        public Criteria andAccountBankProvinceCityIsNull() {
            addCriterion("account_bank_province_city is null");
            return (Criteria) this;
        }

        public Criteria andAccountBankProvinceCityIsNotNull() {
            addCriterion("account_bank_province_city is not null");
            return (Criteria) this;
        }

        public Criteria andAccountBankProvinceCityEqualTo(String value) {
            addCriterion("account_bank_province_city =", value, "accountBankProvinceCity");
            return (Criteria) this;
        }

        public Criteria andAccountBankProvinceCityNotEqualTo(String value) {
            addCriterion("account_bank_province_city <>", value, "accountBankProvinceCity");
            return (Criteria) this;
        }

        public Criteria andAccountBankProvinceCityGreaterThan(String value) {
            addCriterion("account_bank_province_city >", value, "accountBankProvinceCity");
            return (Criteria) this;
        }

        public Criteria andAccountBankProvinceCityGreaterThanOrEqualTo(String value) {
            addCriterion("account_bank_province_city >=", value, "accountBankProvinceCity");
            return (Criteria) this;
        }

        public Criteria andAccountBankProvinceCityLessThan(String value) {
            addCriterion("account_bank_province_city <", value, "accountBankProvinceCity");
            return (Criteria) this;
        }

        public Criteria andAccountBankProvinceCityLessThanOrEqualTo(String value) {
            addCriterion("account_bank_province_city <=", value, "accountBankProvinceCity");
            return (Criteria) this;
        }

        public Criteria andAccountBankProvinceCityLike(String value) {
            addCriterion("account_bank_province_city like", value, "accountBankProvinceCity");
            return (Criteria) this;
        }

        public Criteria andAccountBankProvinceCityNotLike(String value) {
            addCriterion("account_bank_province_city not like", value, "accountBankProvinceCity");
            return (Criteria) this;
        }

        public Criteria andAccountBankProvinceCityIn(List<String> values) {
            addCriterion("account_bank_province_city in", values, "accountBankProvinceCity");
            return (Criteria) this;
        }

        public Criteria andAccountBankProvinceCityNotIn(List<String> values) {
            addCriterion("account_bank_province_city not in", values, "accountBankProvinceCity");
            return (Criteria) this;
        }

        public Criteria andAccountBankProvinceCityBetween(String value1, String value2) {
            addCriterion("account_bank_province_city between", value1, value2, "accountBankProvinceCity");
            return (Criteria) this;
        }

        public Criteria andAccountBankProvinceCityNotBetween(String value1, String value2) {
            addCriterion("account_bank_province_city not between", value1, value2, "accountBankProvinceCity");
            return (Criteria) this;
        }

        public Criteria andBranchNameIsNull() {
            addCriterion("branch_name is null");
            return (Criteria) this;
        }

        public Criteria andBranchNameIsNotNull() {
            addCriterion("branch_name is not null");
            return (Criteria) this;
        }

        public Criteria andBranchNameEqualTo(String value) {
            addCriterion("branch_name =", value, "branchName");
            return (Criteria) this;
        }

        public Criteria andBranchNameNotEqualTo(String value) {
            addCriterion("branch_name <>", value, "branchName");
            return (Criteria) this;
        }

        public Criteria andBranchNameGreaterThan(String value) {
            addCriterion("branch_name >", value, "branchName");
            return (Criteria) this;
        }

        public Criteria andBranchNameGreaterThanOrEqualTo(String value) {
            addCriterion("branch_name >=", value, "branchName");
            return (Criteria) this;
        }

        public Criteria andBranchNameLessThan(String value) {
            addCriterion("branch_name <", value, "branchName");
            return (Criteria) this;
        }

        public Criteria andBranchNameLessThanOrEqualTo(String value) {
            addCriterion("branch_name <=", value, "branchName");
            return (Criteria) this;
        }

        public Criteria andBranchNameLike(String value) {
            addCriterion("branch_name like", value, "branchName");
            return (Criteria) this;
        }

        public Criteria andBranchNameNotLike(String value) {
            addCriterion("branch_name not like", value, "branchName");
            return (Criteria) this;
        }

        public Criteria andBranchNameIn(List<String> values) {
            addCriterion("branch_name in", values, "branchName");
            return (Criteria) this;
        }

        public Criteria andBranchNameNotIn(List<String> values) {
            addCriterion("branch_name not in", values, "branchName");
            return (Criteria) this;
        }

        public Criteria andBranchNameBetween(String value1, String value2) {
            addCriterion("branch_name between", value1, value2, "branchName");
            return (Criteria) this;
        }

        public Criteria andBranchNameNotBetween(String value1, String value2) {
            addCriterion("branch_name not between", value1, value2, "branchName");
            return (Criteria) this;
        }

        public Criteria andAccountBankLinkBankNoIsNull() {
            addCriterion("account_bank_link_bank_no is null");
            return (Criteria) this;
        }

        public Criteria andAccountBankLinkBankNoIsNotNull() {
            addCriterion("account_bank_link_bank_no is not null");
            return (Criteria) this;
        }

        public Criteria andAccountBankLinkBankNoEqualTo(String value) {
            addCriterion("account_bank_link_bank_no =", value, "accountBankLinkBankNo");
            return (Criteria) this;
        }

        public Criteria andAccountBankLinkBankNoNotEqualTo(String value) {
            addCriterion("account_bank_link_bank_no <>", value, "accountBankLinkBankNo");
            return (Criteria) this;
        }

        public Criteria andAccountBankLinkBankNoGreaterThan(String value) {
            addCriterion("account_bank_link_bank_no >", value, "accountBankLinkBankNo");
            return (Criteria) this;
        }

        public Criteria andAccountBankLinkBankNoGreaterThanOrEqualTo(String value) {
            addCriterion("account_bank_link_bank_no >=", value, "accountBankLinkBankNo");
            return (Criteria) this;
        }

        public Criteria andAccountBankLinkBankNoLessThan(String value) {
            addCriterion("account_bank_link_bank_no <", value, "accountBankLinkBankNo");
            return (Criteria) this;
        }

        public Criteria andAccountBankLinkBankNoLessThanOrEqualTo(String value) {
            addCriterion("account_bank_link_bank_no <=", value, "accountBankLinkBankNo");
            return (Criteria) this;
        }

        public Criteria andAccountBankLinkBankNoLike(String value) {
            addCriterion("account_bank_link_bank_no like", value, "accountBankLinkBankNo");
            return (Criteria) this;
        }

        public Criteria andAccountBankLinkBankNoNotLike(String value) {
            addCriterion("account_bank_link_bank_no not like", value, "accountBankLinkBankNo");
            return (Criteria) this;
        }

        public Criteria andAccountBankLinkBankNoIn(List<String> values) {
            addCriterion("account_bank_link_bank_no in", values, "accountBankLinkBankNo");
            return (Criteria) this;
        }

        public Criteria andAccountBankLinkBankNoNotIn(List<String> values) {
            addCriterion("account_bank_link_bank_no not in", values, "accountBankLinkBankNo");
            return (Criteria) this;
        }

        public Criteria andAccountBankLinkBankNoBetween(String value1, String value2) {
            addCriterion("account_bank_link_bank_no between", value1, value2, "accountBankLinkBankNo");
            return (Criteria) this;
        }

        public Criteria andAccountBankLinkBankNoNotBetween(String value1, String value2) {
            addCriterion("account_bank_link_bank_no not between", value1, value2, "accountBankLinkBankNo");
            return (Criteria) this;
        }

        public Criteria andPayableDepositIsNull() {
            addCriterion("payable_deposit is null");
            return (Criteria) this;
        }

        public Criteria andPayableDepositIsNotNull() {
            addCriterion("payable_deposit is not null");
            return (Criteria) this;
        }

        public Criteria andPayableDepositEqualTo(BigDecimal value) {
            addCriterion("payable_deposit =", value, "payableDeposit");
            return (Criteria) this;
        }

        public Criteria andPayableDepositNotEqualTo(BigDecimal value) {
            addCriterion("payable_deposit <>", value, "payableDeposit");
            return (Criteria) this;
        }

        public Criteria andPayableDepositGreaterThan(BigDecimal value) {
            addCriterion("payable_deposit >", value, "payableDeposit");
            return (Criteria) this;
        }

        public Criteria andPayableDepositGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("payable_deposit >=", value, "payableDeposit");
            return (Criteria) this;
        }

        public Criteria andPayableDepositLessThan(BigDecimal value) {
            addCriterion("payable_deposit <", value, "payableDeposit");
            return (Criteria) this;
        }

        public Criteria andPayableDepositLessThanOrEqualTo(BigDecimal value) {
            addCriterion("payable_deposit <=", value, "payableDeposit");
            return (Criteria) this;
        }

        public Criteria andPayableDepositIn(List<BigDecimal> values) {
            addCriterion("payable_deposit in", values, "payableDeposit");
            return (Criteria) this;
        }

        public Criteria andPayableDepositNotIn(List<BigDecimal> values) {
            addCriterion("payable_deposit not in", values, "payableDeposit");
            return (Criteria) this;
        }

        public Criteria andPayableDepositBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("payable_deposit between", value1, value2, "payableDeposit");
            return (Criteria) this;
        }

        public Criteria andPayableDepositNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("payable_deposit not between", value1, value2, "payableDeposit");
            return (Criteria) this;
        }

        public Criteria andDepositPaidIsNull() {
            addCriterion("deposit_paid is null");
            return (Criteria) this;
        }

        public Criteria andDepositPaidIsNotNull() {
            addCriterion("deposit_paid is not null");
            return (Criteria) this;
        }

        public Criteria andDepositPaidEqualTo(BigDecimal value) {
            addCriterion("deposit_paid =", value, "depositPaid");
            return (Criteria) this;
        }

        public Criteria andDepositPaidNotEqualTo(BigDecimal value) {
            addCriterion("deposit_paid <>", value, "depositPaid");
            return (Criteria) this;
        }

        public Criteria andDepositPaidGreaterThan(BigDecimal value) {
            addCriterion("deposit_paid >", value, "depositPaid");
            return (Criteria) this;
        }

        public Criteria andDepositPaidGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("deposit_paid >=", value, "depositPaid");
            return (Criteria) this;
        }

        public Criteria andDepositPaidLessThan(BigDecimal value) {
            addCriterion("deposit_paid <", value, "depositPaid");
            return (Criteria) this;
        }

        public Criteria andDepositPaidLessThanOrEqualTo(BigDecimal value) {
            addCriterion("deposit_paid <=", value, "depositPaid");
            return (Criteria) this;
        }

        public Criteria andDepositPaidIn(List<BigDecimal> values) {
            addCriterion("deposit_paid in", values, "depositPaid");
            return (Criteria) this;
        }

        public Criteria andDepositPaidNotIn(List<BigDecimal> values) {
            addCriterion("deposit_paid not in", values, "depositPaid");
            return (Criteria) this;
        }

        public Criteria andDepositPaidBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("deposit_paid between", value1, value2, "depositPaid");
            return (Criteria) this;
        }

        public Criteria andDepositPaidNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("deposit_paid not between", value1, value2, "depositPaid");
            return (Criteria) this;
        }

        public Criteria andContractStartTimeIsNull() {
            addCriterion("contract_start_time is null");
            return (Criteria) this;
        }

        public Criteria andContractStartTimeIsNotNull() {
            addCriterion("contract_start_time is not null");
            return (Criteria) this;
        }

        public Criteria andContractStartTimeEqualTo(Date value) {
            addCriterion("contract_start_time =", value, "contractStartTime");
            return (Criteria) this;
        }

        public Criteria andContractStartTimeNotEqualTo(Date value) {
            addCriterion("contract_start_time <>", value, "contractStartTime");
            return (Criteria) this;
        }

        public Criteria andContractStartTimeGreaterThan(Date value) {
            addCriterion("contract_start_time >", value, "contractStartTime");
            return (Criteria) this;
        }

        public Criteria andContractStartTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("contract_start_time >=", value, "contractStartTime");
            return (Criteria) this;
        }

        public Criteria andContractStartTimeLessThan(Date value) {
            addCriterion("contract_start_time <", value, "contractStartTime");
            return (Criteria) this;
        }

        public Criteria andContractStartTimeLessThanOrEqualTo(Date value) {
            addCriterion("contract_start_time <=", value, "contractStartTime");
            return (Criteria) this;
        }

        public Criteria andContractStartTimeIn(List<Date> values) {
            addCriterion("contract_start_time in", values, "contractStartTime");
            return (Criteria) this;
        }

        public Criteria andContractStartTimeNotIn(List<Date> values) {
            addCriterion("contract_start_time not in", values, "contractStartTime");
            return (Criteria) this;
        }

        public Criteria andContractStartTimeBetween(Date value1, Date value2) {
            addCriterion("contract_start_time between", value1, value2, "contractStartTime");
            return (Criteria) this;
        }

        public Criteria andContractStartTimeNotBetween(Date value1, Date value2) {
            addCriterion("contract_start_time not between", value1, value2, "contractStartTime");
            return (Criteria) this;
        }

        public Criteria andContractEndTimeIsNull() {
            addCriterion("contract_end_time is null");
            return (Criteria) this;
        }

        public Criteria andContractEndTimeIsNotNull() {
            addCriterion("contract_end_time is not null");
            return (Criteria) this;
        }

        public Criteria andContractEndTimeEqualTo(Date value) {
            addCriterion("contract_end_time =", value, "contractEndTime");
            return (Criteria) this;
        }

        public Criteria andContractEndTimeNotEqualTo(Date value) {
            addCriterion("contract_end_time <>", value, "contractEndTime");
            return (Criteria) this;
        }

        public Criteria andContractEndTimeGreaterThan(Date value) {
            addCriterion("contract_end_time >", value, "contractEndTime");
            return (Criteria) this;
        }

        public Criteria andContractEndTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("contract_end_time >=", value, "contractEndTime");
            return (Criteria) this;
        }

        public Criteria andContractEndTimeLessThan(Date value) {
            addCriterion("contract_end_time <", value, "contractEndTime");
            return (Criteria) this;
        }

        public Criteria andContractEndTimeLessThanOrEqualTo(Date value) {
            addCriterion("contract_end_time <=", value, "contractEndTime");
            return (Criteria) this;
        }

        public Criteria andContractEndTimeIn(List<Date> values) {
            addCriterion("contract_end_time in", values, "contractEndTime");
            return (Criteria) this;
        }

        public Criteria andContractEndTimeNotIn(List<Date> values) {
            addCriterion("contract_end_time not in", values, "contractEndTime");
            return (Criteria) this;
        }

        public Criteria andContractEndTimeBetween(Date value1, Date value2) {
            addCriterion("contract_end_time between", value1, value2, "contractEndTime");
            return (Criteria) this;
        }

        public Criteria andContractEndTimeNotBetween(Date value1, Date value2) {
            addCriterion("contract_end_time not between", value1, value2, "contractEndTime");
            return (Criteria) this;
        }

        public Criteria andLevelIsNull() {
            addCriterion("level is null");
            return (Criteria) this;
        }

        public Criteria andLevelIsNotNull() {
            addCriterion("level is not null");
            return (Criteria) this;
        }

        public Criteria andLevelEqualTo(Integer value) {
            addCriterion("level =", value, "level");
            return (Criteria) this;
        }

        public Criteria andLevelNotEqualTo(Integer value) {
            addCriterion("level <>", value, "level");
            return (Criteria) this;
        }

        public Criteria andLevelGreaterThan(Integer value) {
            addCriterion("level >", value, "level");
            return (Criteria) this;
        }

        public Criteria andLevelGreaterThanOrEqualTo(Integer value) {
            addCriterion("level >=", value, "level");
            return (Criteria) this;
        }

        public Criteria andLevelLessThan(Integer value) {
            addCriterion("level <", value, "level");
            return (Criteria) this;
        }

        public Criteria andLevelLessThanOrEqualTo(Integer value) {
            addCriterion("level <=", value, "level");
            return (Criteria) this;
        }

        public Criteria andLevelIn(List<Integer> values) {
            addCriterion("level in", values, "level");
            return (Criteria) this;
        }

        public Criteria andLevelNotIn(List<Integer> values) {
            addCriterion("level not in", values, "level");
            return (Criteria) this;
        }

        public Criteria andLevelBetween(Integer value1, Integer value2) {
            addCriterion("level between", value1, value2, "level");
            return (Criteria) this;
        }

        public Criteria andLevelNotBetween(Integer value1, Integer value2) {
            addCriterion("level not between", value1, value2, "level");
            return (Criteria) this;
        }

        public Criteria andOfficeAddressIsNull() {
            addCriterion("office_address is null");
            return (Criteria) this;
        }

        public Criteria andOfficeAddressIsNotNull() {
            addCriterion("office_address is not null");
            return (Criteria) this;
        }

        public Criteria andOfficeAddressEqualTo(String value) {
            addCriterion("office_address =", value, "officeAddress");
            return (Criteria) this;
        }

        public Criteria andOfficeAddressNotEqualTo(String value) {
            addCriterion("office_address <>", value, "officeAddress");
            return (Criteria) this;
        }

        public Criteria andOfficeAddressGreaterThan(String value) {
            addCriterion("office_address >", value, "officeAddress");
            return (Criteria) this;
        }

        public Criteria andOfficeAddressGreaterThanOrEqualTo(String value) {
            addCriterion("office_address >=", value, "officeAddress");
            return (Criteria) this;
        }

        public Criteria andOfficeAddressLessThan(String value) {
            addCriterion("office_address <", value, "officeAddress");
            return (Criteria) this;
        }

        public Criteria andOfficeAddressLessThanOrEqualTo(String value) {
            addCriterion("office_address <=", value, "officeAddress");
            return (Criteria) this;
        }

        public Criteria andOfficeAddressLike(String value) {
            addCriterion("office_address like", value, "officeAddress");
            return (Criteria) this;
        }

        public Criteria andOfficeAddressNotLike(String value) {
            addCriterion("office_address not like", value, "officeAddress");
            return (Criteria) this;
        }

        public Criteria andOfficeAddressIn(List<String> values) {
            addCriterion("office_address in", values, "officeAddress");
            return (Criteria) this;
        }

        public Criteria andOfficeAddressNotIn(List<String> values) {
            addCriterion("office_address not in", values, "officeAddress");
            return (Criteria) this;
        }

        public Criteria andOfficeAddressBetween(String value1, String value2) {
            addCriterion("office_address between", value1, value2, "officeAddress");
            return (Criteria) this;
        }

        public Criteria andOfficeAddressNotBetween(String value1, String value2) {
            addCriterion("office_address not between", value1, value2, "officeAddress");
            return (Criteria) this;
        }

        public Criteria andValidityPeriodYearIsNull() {
            addCriterion("validity_period_year is null");
            return (Criteria) this;
        }

        public Criteria andValidityPeriodYearIsNotNull() {
            addCriterion("validity_period_year is not null");
            return (Criteria) this;
        }

        public Criteria andValidityPeriodYearEqualTo(Integer value) {
            addCriterion("validity_period_year =", value, "validityPeriodYear");
            return (Criteria) this;
        }

        public Criteria andValidityPeriodYearNotEqualTo(Integer value) {
            addCriterion("validity_period_year <>", value, "validityPeriodYear");
            return (Criteria) this;
        }

        public Criteria andValidityPeriodYearGreaterThan(Integer value) {
            addCriterion("validity_period_year >", value, "validityPeriodYear");
            return (Criteria) this;
        }

        public Criteria andValidityPeriodYearGreaterThanOrEqualTo(Integer value) {
            addCriterion("validity_period_year >=", value, "validityPeriodYear");
            return (Criteria) this;
        }

        public Criteria andValidityPeriodYearLessThan(Integer value) {
            addCriterion("validity_period_year <", value, "validityPeriodYear");
            return (Criteria) this;
        }

        public Criteria andValidityPeriodYearLessThanOrEqualTo(Integer value) {
            addCriterion("validity_period_year <=", value, "validityPeriodYear");
            return (Criteria) this;
        }

        public Criteria andValidityPeriodYearIn(List<Integer> values) {
            addCriterion("validity_period_year in", values, "validityPeriodYear");
            return (Criteria) this;
        }

        public Criteria andValidityPeriodYearNotIn(List<Integer> values) {
            addCriterion("validity_period_year not in", values, "validityPeriodYear");
            return (Criteria) this;
        }

        public Criteria andValidityPeriodYearBetween(Integer value1, Integer value2) {
            addCriterion("validity_period_year between", value1, value2, "validityPeriodYear");
            return (Criteria) this;
        }

        public Criteria andValidityPeriodYearNotBetween(Integer value1, Integer value2) {
            addCriterion("validity_period_year not between", value1, value2, "validityPeriodYear");
            return (Criteria) this;
        }

        public Criteria andFlageIsNull() {
            addCriterion("flage is null");
            return (Criteria) this;
        }

        public Criteria andFlageIsNotNull() {
            addCriterion("flage is not null");
            return (Criteria) this;
        }

        public Criteria andFlageEqualTo(Integer value) {
            addCriterion("flage =", value, "flage");
            return (Criteria) this;
        }

        public Criteria andFlageNotEqualTo(Integer value) {
            addCriterion("flage <>", value, "flage");
            return (Criteria) this;
        }

        public Criteria andFlageGreaterThan(Integer value) {
            addCriterion("flage >", value, "flage");
            return (Criteria) this;
        }

        public Criteria andFlageGreaterThanOrEqualTo(Integer value) {
            addCriterion("flage >=", value, "flage");
            return (Criteria) this;
        }

        public Criteria andFlageLessThan(Integer value) {
            addCriterion("flage <", value, "flage");
            return (Criteria) this;
        }

        public Criteria andFlageLessThanOrEqualTo(Integer value) {
            addCriterion("flage <=", value, "flage");
            return (Criteria) this;
        }

        public Criteria andFlageIn(List<Integer> values) {
            addCriterion("flage in", values, "flage");
            return (Criteria) this;
        }

        public Criteria andFlageNotIn(List<Integer> values) {
            addCriterion("flage not in", values, "flage");
            return (Criteria) this;
        }

        public Criteria andFlageBetween(Integer value1, Integer value2) {
            addCriterion("flage between", value1, value2, "flage");
            return (Criteria) this;
        }

        public Criteria andFlageNotBetween(Integer value1, Integer value2) {
            addCriterion("flage not between", value1, value2, "flage");
            return (Criteria) this;
        }

        public Criteria andOrderModeIsNull() {
            addCriterion("order_mode is null");
            return (Criteria) this;
        }

        public Criteria andOrderModeIsNotNull() {
            addCriterion("order_mode is not null");
            return (Criteria) this;
        }

        public Criteria andOrderModeEqualTo(Integer value) {
            addCriterion("order_mode =", value, "orderMode");
            return (Criteria) this;
        }

        public Criteria andOrderModeNotEqualTo(Integer value) {
            addCriterion("order_mode <>", value, "orderMode");
            return (Criteria) this;
        }

        public Criteria andOrderModeGreaterThan(Integer value) {
            addCriterion("order_mode >", value, "orderMode");
            return (Criteria) this;
        }

        public Criteria andOrderModeGreaterThanOrEqualTo(Integer value) {
            addCriterion("order_mode >=", value, "orderMode");
            return (Criteria) this;
        }

        public Criteria andOrderModeLessThan(Integer value) {
            addCriterion("order_mode <", value, "orderMode");
            return (Criteria) this;
        }

        public Criteria andOrderModeLessThanOrEqualTo(Integer value) {
            addCriterion("order_mode <=", value, "orderMode");
            return (Criteria) this;
        }

        public Criteria andOrderModeIn(List<Integer> values) {
            addCriterion("order_mode in", values, "orderMode");
            return (Criteria) this;
        }

        public Criteria andOrderModeNotIn(List<Integer> values) {
            addCriterion("order_mode not in", values, "orderMode");
            return (Criteria) this;
        }

        public Criteria andOrderModeBetween(Integer value1, Integer value2) {
            addCriterion("order_mode between", value1, value2, "orderMode");
            return (Criteria) this;
        }

        public Criteria andOrderModeNotBetween(Integer value1, Integer value2) {
            addCriterion("order_mode not between", value1, value2, "orderMode");
            return (Criteria) this;
        }

        public Criteria andPaotuiCoefficientIsNull() {
            addCriterion("paotui_coefficient is null");
            return (Criteria) this;
        }

        public Criteria andPaotuiCoefficientIsNotNull() {
            addCriterion("paotui_coefficient is not null");
            return (Criteria) this;
        }

        public Criteria andPaotuiCoefficientEqualTo(BigDecimal value) {
            addCriterion("paotui_coefficient =", value, "paotuiCoefficient");
            return (Criteria) this;
        }

        public Criteria andPaotuiCoefficientNotEqualTo(BigDecimal value) {
            addCriterion("paotui_coefficient <>", value, "paotuiCoefficient");
            return (Criteria) this;
        }

        public Criteria andPaotuiCoefficientGreaterThan(BigDecimal value) {
            addCriterion("paotui_coefficient >", value, "paotuiCoefficient");
            return (Criteria) this;
        }

        public Criteria andPaotuiCoefficientGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("paotui_coefficient >=", value, "paotuiCoefficient");
            return (Criteria) this;
        }

        public Criteria andPaotuiCoefficientLessThan(BigDecimal value) {
            addCriterion("paotui_coefficient <", value, "paotuiCoefficient");
            return (Criteria) this;
        }

        public Criteria andPaotuiCoefficientLessThanOrEqualTo(BigDecimal value) {
            addCriterion("paotui_coefficient <=", value, "paotuiCoefficient");
            return (Criteria) this;
        }

        public Criteria andPaotuiCoefficientIn(List<BigDecimal> values) {
            addCriterion("paotui_coefficient in", values, "paotuiCoefficient");
            return (Criteria) this;
        }

        public Criteria andPaotuiCoefficientNotIn(List<BigDecimal> values) {
            addCriterion("paotui_coefficient not in", values, "paotuiCoefficient");
            return (Criteria) this;
        }

        public Criteria andPaotuiCoefficientBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("paotui_coefficient between", value1, value2, "paotuiCoefficient");
            return (Criteria) this;
        }

        public Criteria andPaotuiCoefficientNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("paotui_coefficient not between", value1, value2, "paotuiCoefficient");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}